package sist.erp.db.Buy;

import java.sql.SQLException;




import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;


public class PlanManager extends SqlMapClientDaoSupport {

	public PlanVO planSearch(int request_no) throws SQLException{
		return (PlanVO) getSqlMapClientTemplate().queryForObject("planSearch",request_no);
		
	}
	
	public void planInsert(PlanVO vo)throws SQLException{
		getSqlMapClientTemplate().insert("planInsert",vo);
	}
	//max+1
	public int max() throws SQLException{
		return (int) getSqlMapClientTemplate().queryForObject("max");
	}
	
	
	public void delete(int request_no)throws SQLException{
		getSqlMapClientTemplate().delete("planDelete",request_no);
	}
	
}
